﻿CREATE TABLE [dbo].[Produkt](
	[ProduktKey] [int] IDENTITY(1,1) NOT NULL,
	[RoduktTS] [nvarchar](18) NULL,
	[Änderung] [datetime] NULL,
	[HerstellerKey] [int] NULL,
	[LieferantKey] [int] NULL,
	[Bezeichnung] [nvarchar](30) NULL,
	[Artikelnummer] [nvarchar](15) NULL,
	[HauptgruppenKey] [int] NULL,
	[ProduktgruppenKey] [int] NULL,
	[ArtikelKey] [int] NULL,
	[Einkauf] [money] NULL,
	[Verkauf] [money] NULL,
	[VerrechKey] [int] NULL,
	[LeistungsartKey] [int] NULL,
	[ProduktartKey] [int] NULL,
	[VerrechnungssatzKey] [int] NULL,
	[Breite] [float] NULL,
	[Höhe] [float] NULL,
	[Stärke] [float] NULL,
	[m2] [float] NULL,
	[Notiz] [ntext] NULL,
 CONSTRAINT [PK_Produkt] PRIMARY KEY CLUSTERED 
(
	[ProduktKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


